Time Data Import

There are 6 different import formats are available for importing data into timesheets.

One format per company may be selected in the company’s Timesheet definition and will appear as the format on the Time Data Import page.

 

• Browse for the file, Execute to import.
  It will display the data or any errors in the section below and Print can print that data.

• Each import format has different capabilities.
  The two no. 3’s have a default pay item set in the timesheet definition and hours can be allocated to that pay item in the import.
  The other formats require that allocation to be done in the timesheet by the employee or approver.

 

Formats and fields available therein:

• T1 – empno,startdate.starttime,enddate,endtime

• T2 – empno,startdate.starttime,enddate,endtime

• T3 – empno,startdate.starttime,enddate,endtime,allocatehours

• R1 –empno,startdate,starttime,finishtime,totalhours - repeated

• R2 – empno,startdate,starttime,finishtime,totalhours,break - repeated

• R3 - empno,startdate,starttime,finishtime,totalhours,break,allocatehours - repeated

• For examples of each format, contact support@hr3.com.au.

   

Note: Timesheet data may also be inserted into the Ready Pay database through REST API, contact support@hr3.com.au for more information.

 

Return to My Team